pgAdmin Runtime Environment -------------------------------------------------------- Python Path: "C:\Program Files\pgAdmin 4\python\python.exe" Runtime Config File: "C:\Users\h236962\AppData\Roaming\pgadmin4\config.json" Webapp Path: "C:\Program Files\pgAdmin 4\web\pgAdmin4.py" pgAdmin Command: "C:\Program Files\pgAdmin 4\python\python.exe -s C:\Program Files\pgAdmin 4\web\pgAdmin4.py" Environment: - ALLUSERSPROFILE: C:\ProgramData - APPDATA: C:\Users\h236962\AppData\Roaming - CommonProgramFiles: C:\Program Files\Common Files - CommonProgramFiles(x86): C:\Program Files (x86)\Common Files - CommonProgramW6432: C:\Program Files\Common Files - COMPUTERNAME: NTBK0020605 - ComSpec: C:\WINDOWS\system32\cmd.exe - DriverData: C:\Windows\System32\Drivers\DriverData - EFC_13212: 0 - ELECTRON_ENABLE_SECURITY_WARNINGS: false - HOMEDRIVE: C: - HOMEPATH: \Users\h236962 - LOCALAPPDATA: C:\Users\h236962\AppData\Local - LOGONSERVER: \\NP2DCGC20 - NUMBER_OF_PROCESSORS: 12 - OneDrive: C:\Users\h236962\OneDrive - Halliburton - OneDriveCommercial: C:\Users\h236962\OneDrive - Halliburton - ORIGINAL_XDG_CURRENT_DESKTOP: undefined - OS: Windows_NT - Path: C:\Program Files\pgAdmin 4\runtime;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\Pulse Secure\VC142.CRT\X64\;C:\Program Files (x86)\Pulse Secure\VC142.CRT\X86\;C:\Program Files (x86)\Common Files\Pulse Secure\TNC Client Plugin\;C:\Users\h236962\AppData\Local\Microsoft\WindowsApps; - PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC - PGADMIN_INT_KEY: 740f75c0-671e-4ae1-b252-696fefc451b5 - PGADMIN_INT_PORT: 60509 - PGADMIN_SERVER_MODE: OFF - PROCESSOR_ARCHITECTURE: AMD64 - PROCESSOR_IDENTIFIER: AMD64 Family 25 Model 80 Stepping 0, AuthenticAMD - PROCESSOR_LEVEL: 25 - PROCESSOR_REVISION: 5000 - ProgramData: C:\ProgramData - ProgramFiles: C:\Program Files - ProgramFiles(x86): C:\Program Files (x86) - ProgramW6432: C:\Program Files - PSModulePath: C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules - PUBLIC: C:\Users\Public - SESSIONNAME: Console - SNC_LIB: C:\Program Files (x86)\Quest Software\VAS SSO for SAP\qgsskrb5.dll - SNC_LIB_2: C:\Program Files (x86)\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll - SSF_LIBRARY_PATH: C:\Program Files (x86)\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll - SSF_LIBRARY_PATH_64: C:\Program Files\SAP\FrontEnd\SecureLogin\lib\sapcrypto.dll - SystemDrive: C: - SystemRoot: C:\WINDOWS - TEMP: C:\Users\h236962\AppData\Local\Temp - TMP: C:\Users\h236962\AppData\Local\Temp - UATDATA: C:\WINDOWS\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77 - USERDNSDOMAIN: CORP.HALLIBURTON.COM - USERDOMAIN: HALAMERICA - USERDOMAIN_ROAMINGPROFILE: HALAMERICA - USERNAME: H236962 - USERPROFILE: C:\Users\h236962 - windir: C:\WINDOWS - __PSLockDownPolicy: 0 -------------------------------------------------------- Total spawn time to start the pgAdmin4 server: 0.013 Sec 2024-10-14 15:40:11,465: ERROR pgadmin: Table(s) ['query_history', 'database', 'sharedserver', 'macros', 'user_macros', 'user_mfa'] are missing in the database Traceback (most recent call last): File "C:\Program Files\pgAdmin 4\web\pgAdmin4.py", line 103, in app = create_app() ^^^^^^^^^^^^ File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 473, in create_app run_migration_for_sqlite() File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 440, in run_migration_for_sqlite backup_db_file() File "C:\Program Files\pgAdmin 4\web\pgadmin\__init__.py", line 368, in backup_db_file os.rename(SQLITE_PATH, backup_file_name) PermissionError: [WinError 32] The process cannot access the file because it is being used by another process: 'C:\\Users\\h236962\\AppData\\Roaming\\pgAdmin\\pgadmin4.db' -> 'C:\\Users\\h236962\\AppData\\Roaming\\pgAdmin\\pgadmin4.db.20241014154011'